Tableau Strategies by Ann Jackson & Luke Stanke

Author:Ann Jackson & Luke Stanke [Ann Jackson]
Language: eng
Format: epub
Publisher: O'Reilly Media, Inc.
Published: 2021-05-24T16:00:00+00:00

Figure 3-16. An unformatted horizontal bar chart showing total grant dollars in 2019 and a sorted INDEX() value based on the total grant amounts in 2019.

Step 3: Create the difference-in-rank calculation

Step 3a: Index. Create a duplicate of the Index | Grant Amount | 2019 and call the new calculation Index | Grant Amount | 2018.

// Index | Grant Amount | 2018

INDEX()

Step 3b: Delta. For your next calculation you are going to take the difference between the two index calculations. Create a calculation called Index Change | Grant Amount where:

// Index | Grant Amount | 2018

[Index | Grant Amount | 2019] - [Index | Grant Amount | 2018]

Step 3c: Marks card and table calculation. Add this calculation to text on the marks card. Edit the table calculation. You will have the ability to customize both the Index | Grant Amount | 2018 and Index | Grant Amount | 2019.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.